package com.example.score.mapper;

import com.example.score.entity.ClassCourse;
import com.example.score.entity.Teaclass;
import com.example.score.entity.Teaclassuser;
import com.example.score.entity.major;
import com.example.score.entity.vo.TUserVo;
import com.example.score.entity.vo.TUserVos;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
@Mapper
public interface TeaclassuserMapper {
    int inserts(List<Teaclassuser> list);
    int insertbyex(List<Teaclassuser> list);
    int deleteMembers(List<Integer> list);
    List<Integer> selectExits(Integer classId);
    int clearByClassId(Integer classId);
    List<TUserVos> getMembersByClassId(Integer classId);

    List<Teaclass> showAllClassList();

    List<TUserVo> selectAttribute(@Param("nj") Integer nj, @Param("zy") Integer zy, @Param("bj") Integer bj);

    void importGradeStudent(@Param("classId") Integer classId, @Param("courseId")Integer courseId);

    void                                   clearGradeStudent(Integer classId);

    List<Teaclass> RemainingClass();

    int deleteClass1(Integer classId);
    int deleteClass2(Integer classId);
    int deleteClass3(Integer classId);
    int deleteClass4(Integer classId);

    List<major> selectMajor();

    int addMajor(@Param("major_id") Integer major_id, @Param("major_name") String major_name);
    int delMajor(@Param("list") List<Integer> list);

    List<TUserVo> selectUsers(String message);

}
